<!doctype html>
<html>
<head>
    <meta charset="UTF-8">
    <title>baoyuan_数据字典</title>
    <link href="http://cdn.bootcss.com/twitter-bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container"><h1 style="text-align:center;">baoyuan 数据字典</h1>
    <h3>admin_extension_histories</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>bigint(20) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>name</td>
            <td>varchar(100)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>type</td>
            <td>tinyint(4)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>version</td>
            <td>varchar(20)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>detail</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_extensions</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>name</td>
            <td>varchar(100)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>version</td>
            <td>varchar(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>is_enabled</td>
            <td>tinyint(4)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>options</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_menu</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>bigint(20) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>parent_id</td>
            <td>bigint(20)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>order</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>title</td>
            <td>varchar(50)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>icon</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>uri</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>extension</td>
            <td>varchar(50)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>show</td>
            <td>tinyint(4)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_permission_menu</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>permission_id</td>
            <td>bigint(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>menu_id</td>
            <td>bigint(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_permissions</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>bigint(20) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>name</td>
            <td>varchar(50)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>slug</td>
            <td>varchar(50)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>http_method</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>http_path</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>order</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>parent_id</td>
            <td>bigint(20)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_role_menu</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>role_id</td>
            <td>bigint(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>menu_id</td>
            <td>bigint(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_role_permissions</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>role_id</td>
            <td>bigint(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>permission_id</td>
            <td>bigint(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_role_users</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>role_id</td>
            <td>bigint(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>user_id</td>
            <td>bigint(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_roles</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>bigint(20) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>name</td>
            <td>varchar(50)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>slug</td>
            <td>varchar(50)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_settings</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>slug</td>
            <td>varchar(100)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>value</td>
            <td>longtext</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>admin_users</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>bigint(20) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>username</td>
            <td>varchar(120)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>password</td>
            <td>varchar(80)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>avatar</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>remember_token</td>
            <td>varchar(100)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_after_sales商品售后</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>uid</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>reason</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>售后原因</td>
        </tr>
        <tr>
            <td>statsu</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>状态 {0 同意 1 拒接}</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_albums轮播图管理</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>album_id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>album_name</td>
            <td>varchar(80)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>图片名称</td>
        </tr>
        <tr>
            <td>sort</td>
            <td>int(8)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>排序</td>
        </tr>
        <tr>
            <td>cover</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>图片地址</td>
        </tr>
        <tr>
            <td>desc</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>介绍</td>
        </tr>
        <tr>
            <td>activity_url</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>is_default</td>
            <td>tinyint(1)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>是否默认0为默认1为不默认</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_black_ips黑名单</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>black_ip</td>
            <td>varchar(15)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>黑名单</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_blanace</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>主键id</td>
        </tr>
        <tr>
            <td>member_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>用户id</td>
        </tr>
        <tr>
            <td>top_up_type</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>充值方式 0:QQ 1:微信 2:支付宝 3:银行卡</td>
        </tr>
        <tr>
            <td>price</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>充值金额</td>
        </tr>
        <tr>
            <td>up_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>充值时间</td>
        </tr>
        <tr>
            <td>status</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>充值状态 0:待支付 1:已支付 :2失败</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_good_comments商品评论表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>good_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>comment_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_goods商品表,商品数据</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>goods_id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>goods_introduction</td>
            <td>varchar(200)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品介绍</td>
        </tr>
        <tr>
            <td>goods_name</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品名称</td>
        </tr>
        <tr>
            <td>goods_keyname</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>goods_class</td>
            <td>tinyint(1)</td>
            <td>1</td>
            <td>YES</td>
            <td></td>
            <td>商品种类1.促销商品2.热门商品3.精品商品4.首发商品</td>
        </tr>
        <tr>
            <td>goods_class_name</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品种类</td>
        </tr>
        <tr>
            <td>goods_attr_class</td>
            <td>tinyint(4)</td>
            <td>1</td>
            <td>YES</td>
            <td></td>
            <td>商品类型id</td>
        </tr>
        <tr>
            <td>goods_attr_name</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品类型名称</td>
        </tr>
        <tr>
            <td>goods_image</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品主图路径</td>
        </tr>
        <tr>
            <td>goods_content</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品详情</td>
        </tr>
        <tr>
            <td>goods_state</td>
            <td>tinyint(2)</td>
            <td>1</td>
            <td>YES</td>
            <td></td>
            <td>商品状态（1.正常0下架）</td>
        </tr>
        <tr>
            <td>cate_id</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品分类id,逗号隔开</td>
        </tr>
        <tr>
            <td>price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品价格（取第一个sku）</td>
        </tr>
        <tr>
            <td>market_price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>市场价格（取第一个sku）</td>
        </tr>
        <tr>
            <td>cost_price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>成本价（取第一个sku）</td>
        </tr>
        <tr>
            <td>goods_stock</td>
            <td>int(10) unsigned</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>商品库存（总和）</td>
        </tr>
        <tr>
            <td>goods_stock_alarm</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>库存预警</td>
        </tr>
        <tr>
            <td>is_virtual</td>
            <td>int(11)</td>
            <td>1</td>
            <td>YES</td>
            <td></td>
            <td>虚拟商品有效期</td>
        </tr>
        <tr>
            <td>is_free_shipping</td>
            <td>tinyint(1)</td>
            <td>1</td>
            <td>YES</td>
            <td></td>
            <td>是否免邮 0不免邮 1免邮</td>
        </tr>
        <tr>
            <td>shipping_template</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>指定运费模板</td>
        </tr>
        <tr>
            <td>goods_spec_format</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品规格格式id</td>
        </tr>
        <tr>
            <td>goods_attr_format</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品属性格式</td>
        </tr>
        <tr>
            <td>is_delete</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>是否已经删除</td>
        </tr>
        <tr>
            <td>introduction</td>
            <td>varchar(150)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品简介</td>
        </tr>
        <tr>
            <td>keywords</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>关键词</td>
        </tr>
        <tr>
            <td>sort</td>
            <td>int(8)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>排序</td>
        </tr>
        <tr>
            <td>create_time</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>操作时间</td>
        </tr>
        <tr>
            <td>modify_time</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>修改时间</td>
        </tr>
        <tr>
            <td>video_url</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>视频</td>
        </tr>
        <tr>
            <td>sale_num</td>
            <td>int(6)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>销量</td>
        </tr>
        <tr>
            <td>evaluate</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>评价数</td>
        </tr>
        <tr>
            <td>evaluate_shaitu</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>评价晒图数</td>
        </tr>
        <tr>
            <td>evaluate_shipin</td>
            <td>int(6)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>评价视频数</td>
        </tr>
        <tr>
            <td>evaluate_zhuiping</td>
            <td>int(8)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>评价追评数</td>
        </tr>
        <tr>
            <td>evaluate_haoping</td>
            <td>int(8)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>评价好评数</td>
        </tr>
        <tr>
            <td>evaluate_zhongping</td>
            <td>int(8)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>评价中评数</td>
        </tr>
        <tr>
            <td>evaluate_chaping</td>
            <td>int(8)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>评价差评数</td>
        </tr>
        <tr>
            <td>is_consume_discount</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否参与会员等级折扣</td>
        </tr>
        <tr>
            <td>discount_config</td>
            <td>tinyint(1)</td>
            <td>1</td>
            <td>YES</td>
            <td></td>
            <td>规格值</td>
        </tr>
        <tr>
            <td>discount_method</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>优惠方式</td>
        </tr>
        <tr>
            <td>promotion_addon</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>当前参与的营销活动，逗号分隔（限时折扣、团购、拼团、秒杀、专题活动）</td>
        </tr>
        <tr>
            <td>label_id</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品分组id</td>
        </tr>
        <tr>
            <td>virtual_sale</td>
            <td>int(6)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>虚拟销量</td>
        </tr>
        <tr>
            <td>max_buy</td>
            <td>tinyint(4)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>限购</td>
        </tr>
        <tr>
            <td>min_buy</td>
            <td>tinyint(3)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>起购数</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>创建时间</td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>更新时间</td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>删除时间</td>
        </tr>
        <tr>
            <td>evaluate_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>评价详情ID</td>
        </tr>
        <tr>
            <td>skus_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>skuid</td>
        </tr>
        <tr>
            <td>goods_is_not</td>
            <td>tinyint(2)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>0为出售中,1为仓库中商品,2为已售出</td>
        </tr>
        <tr>
            <td>goods_unit</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>单位</td>
        </tr>
        <tr>
            <td>goods_albums</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品轮播图</td>
        </tr>
        <tr>
            <td>goods_integral</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品积分</td>
        </tr>
        <tr>
            <td>goods_numbering</td>
            <td>varchar(225)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品编号</td>
        </tr>
        <tr>
            <td>cmc_store_seckill_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>秒杀ID</td>
        </tr>
        <tr>
            <td>after_sales</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>售后ID</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_goods_carts购物车表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td>购物车ID</td>
        </tr>
        <tr>
            <td>goods_name</td>
            <td>varchar(100)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>购买商品名称</td>
        </tr>
        <tr>
            <td>goods_image</td>
            <td>varchar(150)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>购买商品封面</td>
        </tr>
        <tr>
            <td>goods_num</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>购买商品数量</td>
        </tr>
        <tr>
            <td>goods_price</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>购买商品价格</td>
        </tr>
        <tr>
            <td>goods_type</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>购物商品状态 （1 7天无理由退款 0 不支持退货）</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品ID</td>
        </tr>
        <tr>
            <td>uid</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>用户ID</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_goods_category商品分类表,(三级)</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>category_id</td>
            <td>int(10)</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>category_name</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>分类名称</td>
        </tr>
        <tr>
            <td>short_name</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>简称</td>
        </tr>
        <tr>
            <td>pid</td>
            <td>int(5)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>分类上级id</td>
        </tr>
        <tr>
            <td>level</td>
            <td>tinyint(3)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>等级</td>
        </tr>
        <tr>
            <td>is_show</td>
            <td>tinyint(2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否显示 0显示 1不显示</td>
        </tr>
        <tr>
            <td>sort</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>排序</td>
        </tr>
        <tr>
            <td>image</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>分类图片</td>
        </tr>
        <tr>
            <td>keywords</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>分类页面关键字</td>
        </tr>
        <tr>
            <td>description</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>分类介绍</td>
        </tr>
        <tr>
            <td>attr_class_id</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>关联商品类型id</td>
        </tr>
        <tr>
            <td>attr_class_name</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>关联商品类型名称</td>
        </tr>
        <tr>
            <td>category_id_1</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>一级分类ID</td>
        </tr>
        <tr>
            <td>category_id_2</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>二级分类ID</td>
        </tr>
        <tr>
            <td>category_id_3</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>三级分类ID</td>
        </tr>
        <tr>
            <td>category_full_name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>组装名称</td>
        </tr>
        <tr>
            <td>image_adv</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>分类广告图</td>
        </tr>
        <tr>
            <td>commission_rate</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>佣金比率%</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_goods_collections商品收藏表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>uid</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>status</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>状态 {0 未收藏 1 已收藏}</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_goods_evaluate商品评论表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(11)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td>商品ID</td>
        </tr>
        <tr>
            <td>uid</td>
            <td>int(11)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td>用户Id</td>
        </tr>
        <tr>
            <td>sku_id</td>
            <td>int(11)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td>商品skuid</td>
        </tr>
        <tr>
            <td>goods_name</td>
            <td>varchar(40)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>商品名称</td>
        </tr>
        <tr>
            <td>goods_image</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>商品图片</td>
        </tr>
        <tr>
            <td>product_score</td>
            <td>tinyint(4)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>商品分数</td>
        </tr>
        <tr>
            <td>nickname</td>
            <td>varchar(30)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>评价人名称</td>
        </tr>
        <tr>
            <td>avatar</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>评价人头像</td>
        </tr>
        <tr>
            <td>again_content</td>
            <td>text</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>追加评价内容</td>
        </tr>
        <tr>
            <td>explain_type</td>
            <td>tinyint(1)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td>1好评2中评3差评</td>
        </tr>
        <tr>
            <td>is_show</td>
            <td>tinyint(1)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td>1显示 0隐藏</td>
        </tr>
        <tr>
            <td>add_time</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>评价时间</td>
        </tr>
        <tr>
            <td>is_del</td>
            <td>tinyint(1)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>0未删除1已删除</td>
        </tr>
        <tr>
            <td>is_reply</td>
            <td>tinyint(1)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>0未回复1已回复</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>detail_content</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>1视频/2图片/3追加</td>
        </tr>
        <tr>
            <td>pid</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>评论层级</td>
        </tr>
        <tr>
            <td>look_num</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>浏览次数</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_goods_sku商品的规格,sku</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>sku_id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>商品id</td>
        </tr>
        <tr>
            <td>sku_name</td>
            <td>varchar(120)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品sku名称</td>
        </tr>
        <tr>
            <td>sku_no</td>
            <td>varchar(160)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品sku规格</td>
        </tr>
        <tr>
            <td>sku_spec_format</td>
            <td>varchar(60)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>sku规格值</td>
        </tr>
        <tr>
            <td>stock</td>
            <td>tinyint(4)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>商品sku库存</td>
        </tr>
        <tr>
            <td>weight</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>重量（单位g）</td>
        </tr>
        <tr>
            <td>volume</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>体积（单位立方米）</td>
        </tr>
        <tr>
            <td>sku_image</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>sku主图</td>
        </tr>
        <tr>
            <td>sku_images</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>sku图片</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_members</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>member_id</td>
            <td>int(11) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td>主键</td>
        </tr>
        <tr>
            <td>username</td>
            <td>varchar(80)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>账号</td>
        </tr>
        <tr>
            <td>nickname</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>昵称</td>
        </tr>
        <tr>
            <td>phone</td>
            <td>varchar(30)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>用户手机号</td>
        </tr>
        <tr>
            <td>password</td>
            <td>char(32)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>密码</td>
        </tr>
        <tr>
            <td>status</td>
            <td>tinyint(1)</td>
            <td>1</td>
            <td>YES</td>
            <td></td>
            <td>用户状态 用户状态默认为1</td>
        </tr>
        <tr>
            <td>avatar</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>头像</td>
        </tr>
        <tr>
            <td>qq_openid</td>
            <td>varchar(80)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>qq互联id</td>
        </tr>
        <tr>
            <td>wx_openid</td>
            <td>varchar(80)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>微信openid</td>
        </tr>
        <tr>
            <td>wb_openid</td>
            <td>varchar(80)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>微博openid</td>
        </tr>
        <tr>
            <td>login_ip</td>
            <td>varchar(64)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>登录ip</td>
        </tr>
        <tr>
            <td>last_login_ip</td>
            <td>varchar(64)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>最后登录ip</td>
        </tr>
        <tr>
            <td>reg_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>注册时间</td>
        </tr>
        <tr>
            <td>point</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>积分</td>
        </tr>
        <tr>
            <td>balance</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>余额</td>
        </tr>
        <tr>
            <td>pay_password</td>
            <td>char(32)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>交易密码</td>
        </tr>
        <tr>
            <td>last_login_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>最后登录时间</td>
        </tr>
        <tr>
            <td>sex</td>
            <td>tinyint(1)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>性别 0保密 1男 2女</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_money_record</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>主键</td>
        </tr>
        <tr>
            <td>member_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>用户id</td>
        </tr>
        <tr>
            <td>price</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>金额</td>
        </tr>
        <tr>
            <td>type</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>类型</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_order_shipping_fees运费模板表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>shipping_fee_id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>shipping_fee_name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>运费模板名称</td>
        </tr>
        <tr>
            <td>is_default</td>
            <td>int(11)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td>是否是默认模板</td>
        </tr>
        <tr>
            <td>co_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>物流公司ID</td>
        </tr>
        <tr>
            <td>shop_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>店铺ID</td>
        </tr>
        <tr>
            <td>province_id_array</td>
            <td>text</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>省ID组</td>
        </tr>
        <tr>
            <td>city_id_array</td>
            <td>text</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>市ID组</td>
        </tr>
        <tr>
            <td>weight_is_use</td>
            <td>int(11)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td>是否启用重量运费</td>
        </tr>
        <tr>
            <td>weight_snum</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>首重</td>
        </tr>
        <tr>
            <td>weight_sprice</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>首重运费</td>
        </tr>
        <tr>
            <td>weight_xnum</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>续重</td>
        </tr>
        <tr>
            <td>weight_xprice</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>续重运费</td>
        </tr>
        <tr>
            <td>volume_is_use</td>
            <td>int(11)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td>是否启用体积计算运费</td>
        </tr>
        <tr>
            <td>volume_snum</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>首体积量</td>
        </tr>
        <tr>
            <td>volume_sprice</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>首体积运费</td>
        </tr>
        <tr>
            <td>volume_xnum</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>续体积量</td>
        </tr>
        <tr>
            <td>volume_xprice</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>续体积运费</td>
        </tr>
        <tr>
            <td>bynum_is_use</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>是否启用计件方式运费</td>
        </tr>
        <tr>
            <td>bynum_snum</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>首件</td>
        </tr>
        <tr>
            <td>bynum_sprice</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>首件运费</td>
        </tr>
        <tr>
            <td>bynum_xnum</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>续件</td>
        </tr>
        <tr>
            <td>bynum_xprice</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>续件运费</td>
        </tr>
        <tr>
            <td>create_time</td>
            <td>datetime</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>创建日期</td>
        </tr>
        <tr>
            <td>update_time</td>
            <td>datetime</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>最后更新时间</td>
        </tr>
        <tr>
            <td>district_id_array</td>
            <td>text</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>区县ID组</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_bargain砍价活动表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>bargain_id</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>砍价id</td>
        </tr>
        <tr>
            <td>bargain_name</td>
            <td>varchar(60)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>活动名称</td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品id</td>
        </tr>
        <tr>
            <td>sku_id</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>sku商品id</td>
        </tr>
        <tr>
            <td>bargain_type</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>砍价图片</td>
        </tr>
        <tr>
            <td>status_name</td>
            <td>varchar(30)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品介绍</td>
        </tr>
        <tr>
            <td>first_bargain_price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>砍价价格</td>
        </tr>
        <tr>
            <td>bargain_stock</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>限量</td>
        </tr>
        <tr>
            <td>buy_type</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>限量剩余</td>
        </tr>
        <tr>
            <td>floor_price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>最低价</td>
        </tr>
        <tr>
            <td>is_fenxiao</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>参与人数</td>
        </tr>
        <tr>
            <td>bargain_num</td>
            <td>int(8)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>帮砍价人数</td>
        </tr>
        <tr>
            <td>bargain_time</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>砍价有效期</td>
        </tr>
        <tr>
            <td>cut_num</td>
            <td>tinyint(3)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>总共砍次数</td>
        </tr>
        <tr>
            <td>cut_remaining</td>
            <td>tinyint(3)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>剩余砍价次数</td>
        </tr>
        <tr>
            <td>remark</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>活动规则说明</td>
        </tr>
        <tr>
            <td>start_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>活动开始时间</td>
        </tr>
        <tr>
            <td>end_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>活动结束时间</td>
        </tr>
        <tr>
            <td>min_bar</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>最低砍掉金额</td>
        </tr>
        <tr>
            <td>max_bar</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>最高坎掉金额</td>
        </tr>
        <tr>
            <td>status</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>状态（0未开始 1活动进行中 2活动已结束 3已关闭）</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_bargain_goods砍价商品表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10)</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td>最低价</td>
        </tr>
        <tr>
            <td>bargain_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>砍价id</td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>商品id</td>
        </tr>
        <tr>
            <td>sku_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>sku商品id</td>
        </tr>
        <tr>
            <td>first_bargain_price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>砍价价格</td>
        </tr>
        <tr>
            <td>bargain_stock</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>限量</td>
        </tr>
        <tr>
            <td>floor_price</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>最低价</td>
        </tr>
        <tr>
            <td>bargain_name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>砍价名称</td>
        </tr>
        <tr>
            <td>is_fenxiao</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>参与人数</td>
        </tr>
        <tr>
            <td>buy_type</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>限量剩余</td>
        </tr>
        <tr>
            <td>bargain_type</td>
            <td>varchar(225)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>砍价图片</td>
        </tr>
        <tr>
            <td>bargain_num</td>
            <td>int(8)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>砍价人数</td>
        </tr>
        <tr>
            <td>bargain_time</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>砍价有效期</td>
        </tr>
        <tr>
            <td>remark</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>活动规则说明</td>
        </tr>
        <tr>
            <td>start_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>活动开始时间</td>
        </tr>
        <tr>
            <td>end_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>活动结束时间</td>
        </tr>
        <tr>
            <td>status</td>
            <td>tinyint(1) unsigned</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>状态（0未开始 1活动进行中 2活动已结束 3已关闭）</td>
        </tr>
        <tr>
            <td>status_name</td>
            <td>varchar(40)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>状态名称</td>
        </tr>
        <tr>
            <td>is_own</td>
            <td>int(6)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>砍价次数</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>remark_name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>砍价活动简介</td>
        </tr>
        <tr>
            <td>remark_text</td>
            <td>text</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>砍价活动详情</td>
        </tr>
        <tr>
            <td>unit</td>
            <td>varchar(4)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>单位</td>
        </tr>
        <tr>
            <td>is_shipping</td>
            <td>tinyint(1)</td>
            <td>1</td>
            <td>YES</td>
            <td></td>
            <td>运费模板0包邮1不包邮</td>
        </tr>
        <tr>
            <td>shopp_num</td>
            <td>int(4) unsigned zerofill</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>购买数量限制</td>
        </tr>
        <tr>
            <td>sore</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>排序</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_bargain_launch砍价发起表
    </h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>launch_id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>bargain_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>砍价活动id</td>
        </tr>
        <tr>
            <td>user_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>用户id</td>
        </tr>
        <tr>
            <td>sku_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>商品sku_id</td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>商品id</td>
        </tr>
        <tr>
            <td>sku_name</td>
            <td>varchar(120)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>商品名称</td>
        </tr>
        <tr>
            <td>sku_image</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>商品图</td>
        </tr>
        <tr>
            <td>price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>商品原价</td>
        </tr>
        <tr>
            <td>buy_type</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>购买方式（0元免费拿 1砍到指定价格）</td>
        </tr>
        <tr>
            <td>bargain_type</td>
            <td>tinyint(1)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>砍价金额类型（0固定金额 1随机金额）</td>
        </tr>
        <tr>
            <td>need_num</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>帮砍人数需达到数</td>
        </tr>
        <tr>
            <td>curr_num</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>当前已帮砍人数</td>
        </tr>
        <tr>
            <td>start_time</td>
            <td>datetime</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>开始时间</td>
        </tr>
        <tr>
            <td>status</td>
            <td>tinyint(1)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>0砍价中 1已成功 2未成功</td>
        </tr>
        <tr>
            <td>member_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>砍价发起用户</td>
        </tr>
        <tr>
            <td>nickname</td>
            <td>varchar(120)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>昵称</td>
        </tr>
        <tr>
            <td>headimg</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>头像</td>
        </tr>
        <tr>
            <td>is_fenxiao</td>
            <td>tinyint(1)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>是否参与分销（0不参与 1参与）</td>
        </tr>
        <tr>
            <td>order_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>订单id</td>
        </tr>
        <tr>
            <td>first_bargain_price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>首刀金额</td>
        </tr>
        <tr>
            <td>curr_price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>已砍金额</td>
        </tr>
        <tr>
            <td>is_own</td>
            <td>tinyint(1)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>是否自己砍价（0不支持 1支持）</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_bargain_list用户砍价记录表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(11) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td>主键id</td>
        </tr>
        <tr>
            <td>member_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>用户id</td>
        </tr>
        <tr>
            <td>bargain_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>活动/商品id</td>
        </tr>
        <tr>
            <td>price</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>砍价金额</td>
        </tr>
        <tr>
            <td>old_price</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>当前金额</td>
        </tr>
        <tr>
            <td>need_num</td>
            <td>tinyint(2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>需要次数 /总次数</td>
        </tr>
        <tr>
            <td>curr_num</td>
            <td>tinyint(2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>当前帮砍人数</td>
        </tr>
        <tr>
            <td>old_num</td>
            <td>tinyint(2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>当前剩余砍价次数</td>
        </tr>
        <tr>
            <td>start_time</td>
            <td>datetime</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>开始时间</td>
        </tr>
        <tr>
            <td>end_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>结束时间</td>
        </tr>
        <tr>
            <td>status</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>砍价状态 0进行中 1已完成 2:失败</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td>CURRENT_TIMESTAMP</td>
            <td>NO</td>
            <td></td>
            <td>创建时间</td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>修改时间</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_bargain_record用户帮砍表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>member_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>砍价发起会员id</td>
        </tr>
        <tr>
            <td>help_member_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>帮砍会员id</td>
        </tr>
        <tr>
            <td>nickname</td>
            <td>varchar(80)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>昵称</td>
        </tr>
        <tr>
            <td>headimg</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>头像</td>
        </tr>
        <tr>
            <td>money</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>帮砍金额</td>
        </tr>
        <tr>
            <td>old_price</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>剩余价格</td>
        </tr>
        <tr>
            <td>old_num</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>剩余砍价次数</td>
        </tr>
        <tr>
            <td>bargain_time</td>
            <td>datetime</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>帮砍时间</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_coupon优惠券表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>title</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>优惠券名称</td>
        </tr>
        <tr>
            <td>integral</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>兑换消耗</td>
        </tr>
        <tr>
            <td>coupon_price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>兑换优惠券面值</td>
        </tr>
        <tr>
            <td>coupon_time</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>优惠券有效期(天)</td>
        </tr>
        <tr>
            <td>sort</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>排序</td>
        </tr>
        <tr>
            <td>status</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>优惠券状态</td>
        </tr>
        <tr>
            <td>add_time</td>
            <td>datetime</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>兑换开始时间</td>
        </tr>
        <tr>
            <td>id_del</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>是否删除</td>
        </tr>
        <tr>
            <td>goods_name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>所属商品</td>
        </tr>
        <tr>
            <td>category_name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>所属分类</td>
        </tr>
        <tr>
            <td>type</td>
            <td>varchar(50)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>优惠券类型 0-通用 1-品类券 2-商品券</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_coupon_type优惠券配置表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>type</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>优惠券类型</td>
        </tr>
        <tr>
            <td>status</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>优惠券状态</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_pintuan拼团活动表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>pintuan_id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>site_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>店铺ID</td>
        </tr>
        <tr>
            <td>site_name</td>
            <td>varchar(120)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>店铺名称</td>
        </tr>
        <tr>
            <td>pintuan_name</td>
            <td>varchar(120)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>活动名称</td>
        </tr>
        <tr>
            <td>uid</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品ID</td>
        </tr>
        <tr>
            <td>is_virtual_goods</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否虚拟</td>
        </tr>
        <tr>
            <td>pintuan_num</td>
            <td>tinyint(3)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>参团人数（最多参与人数）</td>
        </tr>
        <tr>
            <td>pintuan_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团有效期</td>
        </tr>
        <tr>
            <td>goods_name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>remark</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>备注</td>
        </tr>
        <tr>
            <td>is_recommend</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否推荐</td>
        </tr>
        <tr>
            <td>start_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>开始时间</td>
        </tr>
        <tr>
            <td>end_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>结束时间</td>
        </tr>
        <tr>
            <td>buy_num</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团限制购买（拼团最多人数）</td>
        </tr>
        <tr>
            <td>pintuan_price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团价</td>
        </tr>
        <tr>
            <td>is_virtual_buy</td>
            <td>char(2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否虚拟成团</td>
        </tr>
        <tr>
            <td>is_single_buy</td>
            <td>char(2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否单独购买</td>
        </tr>
        <tr>
            <td>is_promotion</td>
            <td>varchar(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否团长优惠</td>
        </tr>
        <tr>
            <td>group_num</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>拼团限制(最多可以有多少组)</td>
        </tr>
        <tr>
            <td>order_num</td>
            <td>tinyint(8)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>购买人数（当前购买人数）</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>pintuan_image</td>
            <td>varchar(100)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团封面图片</td>
        </tr>
        <tr>
            <td>group_count</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团组数（多少组参与）</td>
        </tr>
        <tr>
            <td>status</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>状态（0 下架 1 正常）</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_pintuan_goods拼团商品表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品ID</td>
        </tr>
        <tr>
            <td>sku_id</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>skuid</td>
        </tr>
        <tr>
            <td>pintuan_price</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团价格</td>
        </tr>
        <tr>
            <td>promotion_price</td>
            <td>decimal(10,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>团长优惠价</td>
        </tr>
        <tr>
            <td>site_id</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>站点id</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>pintuan_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团ID</td>
        </tr>
        <tr>
            <td>pintuan_images</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团商品图片</td>
        </tr>
        <tr>
            <td>end_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团结束时间</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_pintuan_group拼团组</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>group_id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>site_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>店铺ID</td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品ID</td>
        </tr>
        <tr>
            <td>is_virtual_goods</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否虚拟商品</td>
        </tr>
        <tr>
            <td>pintuan_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团活动ID</td>
        </tr>
        <tr>
            <td>head_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>团长ID</td>
        </tr>
        <tr>
            <td>pintuan_num</td>
            <td>int(8)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团数量</td>
        </tr>
        <tr>
            <td>pintuan_count</td>
            <td>int(8)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>当前数量</td>
        </tr>
        <tr>
            <td>end_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团结束时间</td>
        </tr>
        <tr>
            <td>status</td>
            <td>tinyint(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>当前状态 0未支付 1拼团失败 2.组团中3.拼团成功</td>
        </tr>
        <tr>
            <td>is_virtual_buy</td>
            <td>char(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否虚拟成团</td>
        </tr>
        <tr>
            <td>is_single_buy</td>
            <td>char(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否单独购买</td>
        </tr>
        <tr>
            <td>is_promotion</td>
            <td>char(1)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>是否团长优惠</td>
        </tr>
        <tr>
            <td>buy_num</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团限制购买</td>
        </tr>
        <tr>
            <td>head_member_img</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>组长会员头像</td>
        </tr>
        <tr>
            <td>head_nickname</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>组长会员昵称</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>addr_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>收货地址ID</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_promotion_pintuan_order拼团订单表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>pintuan_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团ID</td>
        </tr>
        <tr>
            <td>order_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>订单ID</td>
        </tr>
        <tr>
            <td>site_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>站点ID</td>
        </tr>
        <tr>
            <td>order_no</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>订单编号</td>
        </tr>
        <tr>
            <td>pintuan_status</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>状态</td>
        </tr>
        <tr>
            <td>order_type</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>订单类型</td>
        </tr>
        <tr>
            <td>head_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>团长ID</td>
        </tr>
        <tr>
            <td>member_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>订单会员ID</td>
        </tr>
        <tr>
            <td>member_img</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>会员头像</td>
        </tr>
        <tr>
            <td>nickname</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>会员昵称</td>
        </tr>
        <tr>
            <td>group_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>拼团分组ID</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_qq_accounts</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(11) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td>主键id</td>
        </tr>
        <tr>
            <td>member_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>关联用户id</td>
        </tr>
        <tr>
            <td>openid</td>
            <td>varchar(100)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>QQ唯一标识</td>
        </tr>
        <tr>
            <td>access_token</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>QQ token</td>
        </tr>
        <tr>
            <td>userinfo</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>QQ头像</td>
        </tr>
        <tr>
            <td>status</td>
            <td>tinyint(1)</td>
            <td>1</td>
            <td>YES</td>
            <td></td>
            <td>0未关联 ,1关联</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_shipping_address</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(11) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td>主键id</td>
        </tr>
        <tr>
            <td>name</td>
            <td>varchar(20)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>收货人姓名</td>
        </tr>
        <tr>
            <td>phone</td>
            <td>char(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>收货人手机号</td>
        </tr>
        <tr>
            <td>city</td>
            <td>varchar(20)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>市</td>
        </tr>
        <tr>
            <td>area</td>
            <td>varchar(20)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>区</td>
        </tr>
        <tr>
            <td>address</td>
            <td>varchar(80)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>详细地址</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_speckillshoppingcards收货地址</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>card_id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>seckill_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>秒杀商品id</td>
        </tr>
        <tr>
            <td>user_id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>user_id</td>
        </tr>
        <tr>
            <td>speckill_num</td>
            <td>tinyint(4)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>秒杀商品数量</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_store_seckill秒杀活动表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>category_name</td>
            <td>varchar(50)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品分类名称</td>
        </tr>
        <tr>
            <td>seckill_name</td>
            <td>varchar(180)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>秒杀活动标题</td>
        </tr>
        <tr>
            <td>seckill_info</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>简介</td>
        </tr>
        <tr>
            <td>images</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>秒杀活动图片</td>
        </tr>
        <tr>
            <td>price</td>
            <td>decimal(8,2)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>秒杀价格</td>
        </tr>
        <tr>
            <td>sort</td>
            <td>int(11)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>排序</td>
        </tr>
        <tr>
            <td>status</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品状态</td>
        </tr>
        <tr>
            <td>start_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>开始时间</td>
        </tr>
        <tr>
            <td>end_time</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>结束时间</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>stock</td>
            <td>int(10)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>秒杀库存</td>
        </tr>
        <tr>
            <td>paid_num</td>
            <td>int(10)</td>
            <td>0</td>
            <td>YES</td>
            <td></td>
            <td>已支付数量</td>
        </tr>
        <tr>
            <td>goods_name</td>
            <td>varchar(120)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品名称</td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>商品ID</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_store_seckill_rules秒杀配置表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>seckill_name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>秒杀名称</td>
        </tr>
        <tr>
            <td>images</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>轮播图</td>
        </tr>
        <tr>
            <td>status</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>秒杀状态</td>
        </tr>
        <tr>
            <td>is_show</td>
            <td>char(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>是否显示</td>
        </tr>
        <tr>
            <td>goods_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>add_time</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>秒杀时段</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_system_city城市表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>city_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>城市id</td>
        </tr>
        <tr>
            <td>level</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>省市级别</td>
        </tr>
        <tr>
            <td>parent_id</td>
            <td>int(11)</td>
            <td>0</td>
            <td>NO</td>
            <td></td>
            <td>父级id</td>
        </tr>
        <tr>
            <td>area_code</td>
            <td>varchar(30)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>区号</td>
        </tr>
        <tr>
            <td>name</td>
            <td>varchar(100)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>名称</td>
        </tr>
        <tr>
            <td>merger_name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>合并名称</td>
        </tr>
        <tr>
            <td>lng</td>
            <td>varchar(50)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>经度</td>
        </tr>
        <tr>
            <td>lat</td>
            <td>varchar(50)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td>纬度</td>
        </tr>
        <tr>
            <td>is_show</td>
            <td>tinyint(1)</td>
            <td>1</td>
            <td>NO</td>
            <td></td>
            <td>是否展示</td>
        </tr>
        </tbody>
    </table>
    <h3>cmc_user_seckills用户秒杀表</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>uid</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>秒杀用户ID</td>
        </tr>
        <tr>
            <td>seckill_id</td>
            <td>int(11)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>秒杀活动ID</td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>deleted_at</td>
            <td>datetime</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>status</td>
            <td>varchar(255)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td>秒杀状态 {0 正常 1 长时间未支付 2 支付成功}</td>
        </tr>
        </tbody>
    </table>
    <h3>failed_jobs</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>bigint(20) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>uuid</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>connection</td>
            <td>text</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>queue</td>
            <td>text</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>payload</td>
            <td>longtext</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>exception</td>
            <td>longtext</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>failed_at</td>
            <td>timestamp</td>
            <td>CURRENT_TIMESTAMP</td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>migrations</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>int(10) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>migration</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>batch</td>
            <td>int(11)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>password_resets</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>email</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>token</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
    <h3>users</h3>
    <table class="table table-hover table-bordered table-condensed">
        <thead>
        <tr>
            <th>字段名</th>
            <th>数据类型</th>
            <th>默认值</th>
            <th>允许非空</th>
            <th>自动递增</th>
            <th>备注</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>bigint(20) unsigned</td>
            <td></td>
            <td>NO</td>
            <td>是</td>
            <td></td>
        </tr>
        <tr>
            <td>name</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>email</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>email_verified_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>password</td>
            <td>varchar(255)</td>
            <td></td>
            <td>NO</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>remember_token</td>
            <td>varchar(100)</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>created_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        <tr>
            <td>updated_at</td>
            <td>timestamp</td>
            <td></td>
            <td>YES</td>
            <td></td>
            <td></td>
        </tr>
        </tbody>
    </table>
</div>
</body>
</html>